Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 20279 |
| Missing cells | 12956 |
| Missing cells (%) | 3.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 9.3 MiB |
| Average record size in memory | 480.6 B |
Variable types
| NUM | 11 |
|---|---|
| CAT | 5 |
| BOOL | 1 |
Reproduction
| Analysis started | 2020-05-20 15:47:39.520144 |
|---|---|
| Analysis finished | 2020-05-20 15:48:33.955742 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
gift_id has a high cardinality: 20279 distinct values | High cardinality |
instock_date has a high cardinality: 17147 distinct values | High cardinality |
stock_update_date has a high cardinality: 14794 distinct values | High cardinality |
uk_date1 has a high cardinality: 16384 distinct values | High cardinality |
uk_date2 has a high cardinality: 7210 distinct values | High cardinality |
volumes has 12956 (63.9%) missing values | Missing |
instock_date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
stock_update_date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
uk_date1 only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
uk_date2 only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
gift_cluster has 3568 (17.6%) zeros | Zeros |
| Distinct count | 20279 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 158.6 KiB |
| GF_15330 | 1 |
|---|---|
| GF_14569 | 1 |
| GF_19303 | 1 |
| GF_20189 | 1 |
| GF_11946 | 1 |
| Other values (20274) |
| Value | Count | Frequency (%) | |
| GF_15330 | 1 | < 0.1% | |
| GF_14569 | 1 | < 0.1% | |
| GF_19303 | 1 | < 0.1% | |
| GF_20189 | 1 | < 0.1% | |
| GF_11946 | 1 | < 0.1% | |
| GF_19220 | 1 | < 0.1% | |
| GF_13718 | 1 | < 0.1% | |
| GF_24271 | 1 | < 0.1% | |
| GF_10883 | 1 | < 0.1% | |
| GF_18968 | 1 | < 0.1% | |
| Other values (20269) | 20269 | > 99.9% |
Length
| Max length | 8 |
|---|---|
| Mean length | 7.559593668 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 76.9% | |
| Uppercase_Letter | 2 | 15.4% | |
| Connector_Punctuation | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Common | 11 | 84.6% | |
| Latin | 2 | 15.4% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
gift_type
Real number (ℝ≥0)
| Distinct count | 1237 |
|---|---|
| Unique (%) | 6.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 739.5546625 |
|---|---|
| Minimum | 1 |
| Maximum | 1360 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 66 |
| Q1 | 403 |
| median | 825 |
| Q3 | 1032 |
| 95-th percentile | 1271 |
| Maximum | 1360 |
| Range | 1359 |
| Interquartile range (IQR) | 629 |
Descriptive statistics
| Standard deviation | 389.2169888 |
|---|---|
| Coefficient of variation (CV) | 0.5262856264 |
| Kurtosis | -1.148934749 |
| Mean | 739.5546625 |
| Median Absolute Deviation (MAD) | 339.8746067 |
| Skewness | -0.2776329907 |
| Sum | 14997429 |
| Variance | 151489.8643 |
| Value | Count | Frequency (%) | |
| 1008 | 988 | 4.9% | |
| 1266 | 982 | 4.8% | |
| 660 | 889 | 4.4% | |
| 992 | 550 | 2.7% | |
| 896 | 493 | 2.4% | |
| 908 | 376 | 1.9% | |
| 1173 | 355 | 1.8% | |
| 415 | 347 | 1.7% | |
| 1111 | 318 | 1.6% | |
| 899 | 297 | 1.5% | |
| Other values (1227) | 14684 | 72.4% |
| Value | Count | Frequency (%) | |
| 1 | 5 | < 0.1% | |
| 2 | 3 | < 0.1% | |
| 3 | 19 | 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1360 | 1 | < 0.1% | |
| 1357 | 2 | < 0.1% | |
| 1356 | 2 | < 0.1% | |
| 1355 | 5 | < 0.1% | |
| 1354 | 6 | < 0.1% |
gift_category
Real number (ℝ≥0)
| Distinct count | 852 |
|---|---|
| Unique (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 394.1715568 |
|---|---|
| Minimum | 1 |
| Maximum | 893 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 38 |
| Q1 | 188 |
| median | 433 |
| Q3 | 534 |
| 95-th percentile | 815 |
| Maximum | 893 |
| Range | 892 |
| Interquartile range (IQR) | 346 |
Descriptive statistics
| Standard deviation | 235.0777687 |
|---|---|
| Coefficient of variation (CV) | 0.5963844035 |
| Kurtosis | -0.9591278385 |
| Mean | 394.1715568 |
| Median Absolute Deviation (MAD) | 201.8403781 |
| Skewness | 0.1777879101 |
| Sum | 7993405 |
| Variance | 55261.55736 |
| Value | Count | Frequency (%) | |
| 188 | 2723 | 13.4% | |
| 534 | 2064 | 10.2% | |
| 433 | 1257 | 6.2% | |
| 38 | 643 | 3.2% | |
| 822 | 490 | 2.4% | |
| 305 | 400 | 2.0% | |
| 610 | 304 | 1.5% | |
| 450 | 284 | 1.4% | |
| 282 | 279 | 1.4% | |
| 12 | 275 | 1.4% | |
| Other values (842) | 11560 | 57.0% |
| Value | Count | Frequency (%) | |
| 1 | 4 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 4 | < 0.1% | |
| 6 | 4 | < 0.1% | |
| 7 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 893 | 3 | < 0.1% | |
| 892 | 2 | < 0.1% | |
| 891 | 1 | < 0.1% | |
| 890 | 5 | < 0.1% | |
| 889 | 7 | < 0.1% |
| Distinct count | 5414 |
|---|---|
| Unique (%) | 26.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3303.358548 |
|---|---|
| Minimum | 0 |
| Maximum | 7567 |
| Zeros | 3568 |
| Zeros (%) | 17.6% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 587 |
| median | 3231 |
| Q3 | 5787 |
| 95-th percentile | 7213 |
| Maximum | 7567 |
| Range | 7567 |
| Interquartile range (IQR) | 5200 |
Descriptive statistics
| Standard deviation | 2541.082549 |
|---|---|
| Coefficient of variation (CV) | 0.7692421249 |
| Kurtosis | -1.350521372 |
| Mean | 3303.358548 |
| Median Absolute Deviation (MAD) | 2210.610126 |
| Skewness | 0.1211027051 |
| Sum | 66988808 |
| Variance | 6457100.52 |
| Value | Count | Frequency (%) | |
| 0 | 3568 | 17.6% | |
| 6489 | 60 | 0.3% | |
| 3371 | 59 | 0.3% | |
| 260 | 57 | 0.3% | |
| 6490 | 53 | 0.3% | |
| 6936 | 53 | 0.3% | |
| 6935 | 53 | 0.3% | |
| 2693 | 53 | 0.3% | |
| 2694 | 52 | 0.3% | |
| 2695 | 51 | 0.3% | |
| Other values (5404) | 16220 | 80.0% |
| Value | Count | Frequency (%) | |
| 0 | 3568 | 17.6% | |
| 1 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7567 | 8 | < 0.1% | |
| 7566 | 1 | < 0.1% | |
| 7565 | 1 | < 0.1% | |
| 7564 | 4 | < 0.1% | |
| 7563 | 2 | < 0.1% |
| Distinct count | 17147 |
|---|---|
| Unique (%) | 84.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 158.6 KiB |
| 2015-09-25 13:22:53.000 | 7 |
|---|---|
| 2015-09-22 14:30:05.000 | 7 |
| 2015-05-06 17:20:59.000 | 7 |
| 2015-05-05 14:09:22.000 | 7 |
| 2016-03-29 21:55:43.000 | 7 |
| Other values (17142) |
| Value | Count | Frequency (%) | |
| 2015-09-25 13:22:53.000 | 7 | < 0.1% | |
| 2015-09-22 14:30:05.000 | 7 | < 0.1% | |
| 2015-05-06 17:20:59.000 | 7 | < 0.1% | |
| 2015-05-05 14:09:22.000 | 7 | < 0.1% | |
| 2016-03-29 21:55:43.000 | 7 | < 0.1% | |
| 2015-09-22 15:24:59.000 | 6 | < 0.1% | |
| 2015-08-21 21:36:19.000 | 6 | < 0.1% | |
| 2016-03-29 22:54:54.000 | 6 | < 0.1% | |
| 2015-08-22 19:36:19.000 | 6 | < 0.1% | |
| 2015-05-09 13:10:20.000 | 6 | < 0.1% | |
| Other values (17137) | 20214 | 99.7% |
Length
| Max length | 23 |
|---|---|
| Mean length | 23 |
| Min length | 23 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 71.4% | |
| Other_Punctuation | 2 | 14.3% | |
| Space_Separator | 1 | 7.1% | |
| Dash_Punctuation | 1 | 7.1% |
| Value | Count | Frequency (%) | |
| Common | 14 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 14 | 100.0% |
| Distinct count | 14794 |
|---|---|
| Unique (%) | 73.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 158.6 KiB |
| 2017-03-12 18:39:44.000 | 17 |
|---|---|
| 2017-03-12 20:39:44.000 | 14 |
| 2017-03-11 17:39:44.000 | 14 |
| 2017-04-02 15:42:25.000 | 13 |
| 2017-03-12 16:39:44.000 | 13 |
| Other values (14789) |
| Value | Count | Frequency (%) | |
| 2017-03-12 18:39:44.000 | 17 | 0.1% | |
| 2017-03-12 20:39:44.000 | 14 | 0.1% | |
| 2017-03-11 17:39:44.000 | 14 | 0.1% | |
| 2017-04-02 15:42:25.000 | 13 | 0.1% | |
| 2017-03-12 16:39:44.000 | 13 | 0.1% | |
| 2017-03-12 19:39:44.000 | 12 | 0.1% | |
| 2017-04-03 15:42:26.000 | 11 | 0.1% | |
| 2017-03-07 20:37:24.000 | 11 | 0.1% | |
| 2017-03-12 18:41:37.000 | 11 | 0.1% | |
| 2017-03-11 16:39:44.000 | 11 | 0.1% | |
| Other values (14784) | 20152 | 99.4% |
Length
| Max length | 23 |
|---|---|
| Mean length | 23 |
| Min length | 23 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 71.4% | |
| Other_Punctuation | 2 | 14.3% | |
| Space_Separator | 1 | 7.1% | |
| Dash_Punctuation | 1 | 7.1% |
| Value | Count | Frequency (%) | |
| Common | 14 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 14 | 100.0% |
lsg_1
Real number (ℝ≥0)
| Distinct count | 7464 |
|---|---|
| Unique (%) | 36.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5314.595345 |
|---|---|
| Minimum | 0 |
| Maximum | 9979 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 676.9 |
| Q1 | 3311 |
| median | 5520 |
| Q3 | 7535 |
| 95-th percentile | 9432 |
| Maximum | 9979 |
| Range | 9979 |
| Interquartile range (IQR) | 4224 |
Descriptive statistics
| Standard deviation | 2703.317282 |
|---|---|
| Coefficient of variation (CV) | 0.5086590994 |
| Kurtosis | -1.00388407 |
| Mean | 5314.595345 |
| Median Absolute Deviation (MAD) | 2283.403914 |
| Skewness | -0.1493298783 |
| Sum | 107774679 |
| Variance | 7307924.325 |
| Value | Count | Frequency (%) | |
| 8604 | 79 | 0.4% | |
| 9432 | 60 | 0.3% | |
| 6977 | 59 | 0.3% | |
| 5543 | 57 | 0.3% | |
| 7529 | 54 | 0.3% | |
| 9433 | 53 | 0.3% | |
| 6980 | 53 | 0.3% | |
| 5574 | 53 | 0.3% | |
| 6988 | 53 | 0.3% | |
| 5577 | 52 | 0.3% | |
| Other values (7454) | 19706 | 97.2% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 4 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9979 | 1 | < 0.1% | |
| 9978 | 1 | < 0.1% | |
| 9977 | 2 | < 0.1% | |
| 9976 | 2 | < 0.1% | |
| 9975 | 2 | < 0.1% |
lsg_2
Real number (ℝ≥0)
| Distinct count | 5310 |
|---|---|
| Unique (%) | 26.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4187.653928 |
|---|---|
| Minimum | 0 |
| Maximum | 7604 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 576 |
| Q1 | 2251 |
| median | 4246 |
| Q3 | 6504.5 |
| 95-th percentile | 7205 |
| Maximum | 7604 |
| Range | 7604 |
| Interquartile range (IQR) | 4253.5 |
Descriptive statistics
| Standard deviation | 2274.875522 |
|---|---|
| Coefficient of variation (CV) | 0.5432338873 |
| Kurtosis | -1.354571927 |
| Mean | 4187.653928 |
| Median Absolute Deviation (MAD) | 2028.057086 |
| Skewness | -0.1343378906 |
| Sum | 84921434 |
| Variance | 5175058.64 |
| Value | Count | Frequency (%) | |
| 6883 | 2037 | 10.0% | |
| 2250 | 223 | 1.1% | |
| 4404 | 130 | 0.6% | |
| 915 | 79 | 0.4% | |
| 7186 | 60 | 0.3% | |
| 7103 | 59 | 0.3% | |
| 6408 | 57 | 0.3% | |
| 2872 | 54 | 0.3% | |
| 7172 | 53 | 0.3% | |
| 7205 | 53 | 0.3% | |
| Other values (5300) | 17474 | 86.2% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 3 | 3 | < 0.1% | |
| 6 | 2 | < 0.1% | |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7604 | 2 | < 0.1% | |
| 7603 | 1 | < 0.1% | |
| 7602 | 1 | < 0.1% | |
| 7601 | 1 | < 0.1% | |
| 7600 | 3 | < 0.1% |
lsg_3
Real number (ℝ≥0)
| Distinct count | 7032 |
|---|---|
| Unique (%) | 34.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4866.94551 |
|---|---|
| Minimum | 0 |
| Maximum | 9493 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 653 |
| Q1 | 2548 |
| median | 4839 |
| Q3 | 7387 |
| 95-th percentile | 8879 |
| Maximum | 9493 |
| Range | 9493 |
| Interquartile range (IQR) | 4839 |
Descriptive statistics
| Standard deviation | 2713.856392 |
|---|---|
| Coefficient of variation (CV) | 0.5576097753 |
| Kurtosis | -1.252581449 |
| Mean | 4866.94551 |
| Median Absolute Deviation (MAD) | 2375.241978 |
| Skewness | -0.02108544396 |
| Sum | 98696788 |
| Variance | 7365016.517 |
| Value | Count | Frequency (%) | |
| 7995 | 130 | 0.6% | |
| 7114 | 79 | 0.4% | |
| 8539 | 60 | 0.3% | |
| 8528 | 59 | 0.3% | |
| 3541 | 57 | 0.3% | |
| 5777 | 54 | 0.3% | |
| 3540 | 53 | 0.3% | |
| 8541 | 53 | 0.3% | |
| 8545 | 53 | 0.3% | |
| 8540 | 53 | 0.3% | |
| Other values (7022) | 19628 | 96.8% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9493 | 2 | < 0.1% | |
| 9492 | 1 | < 0.1% | |
| 9491 | 2 | < 0.1% | |
| 9490 | 2 | < 0.1% | |
| 9489 | 2 | < 0.1% |
lsg_4
Real number (ℝ≥0)
| Distinct count | 1269 |
|---|---|
| Unique (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1679.152226 |
|---|---|
| Minimum | 3 |
| Maximum | 2056 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 406 |
| Q1 | 1801 |
| median | 1912 |
| Q3 | 1912 |
| 95-th percentile | 1912 |
| Maximum | 2056 |
| Range | 2053 |
| Interquartile range (IQR) | 111 |
Descriptive statistics
| Standard deviation | 485.699119 |
|---|---|
| Coefficient of variation (CV) | 0.2892525832 |
| Kurtosis | 2.474228067 |
| Mean | 1679.152226 |
| Median Absolute Deviation (MAD) | 349.439593 |
| Skewness | -2.000614206 |
| Sum | 34051528 |
| Variance | 235903.6342 |
| Value | Count | Frequency (%) | |
| 1912 | 13076 | 64.5% | |
| 406 | 533 | 2.6% | |
| 1873 | 233 | 1.1% | |
| 1887 | 132 | 0.7% | |
| 1845 | 125 | 0.6% | |
| 1816 | 120 | 0.6% | |
| 1786 | 118 | 0.6% | |
| 1859 | 110 | 0.5% | |
| 1705 | 107 | 0.5% | |
| 591 | 89 | 0.4% | |
| Other values (1259) | 5636 | 27.8% |
| Value | Count | Frequency (%) | |
| 3 | 8 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2056 | 1 | < 0.1% | |
| 2055 | 1 | < 0.1% | |
| 2054 | 1 | < 0.1% | |
| 2053 | 1 | < 0.1% | |
| 2052 | 1 | < 0.1% |
lsg_5
Real number (ℝ≥0)
| Distinct count | 11 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.652694906 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 9 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.34938795 |
|---|---|
| Coefficient of variation (CV) | 0.2715209511 |
| Kurtosis | 5.437682115 |
| Mean | 8.652694906 |
| Median Absolute Deviation (MAD) | 1.366414041 |
| Skewness | -2.6002019 |
| Sum | 175468 |
| Variance | 5.519623741 |
| Value | Count | Frequency (%) | |
| 9 | 10390 | 51.2% | |
| 10 | 7605 | 37.5% | |
| 1 | 1369 | 6.8% | |
| 3 | 404 | 2.0% | |
| 8 | 247 | 1.2% | |
| 6 | 127 | 0.6% | |
| 4 | 105 | 0.5% | |
| 7 | 15 | 0.1% | |
| 5 | 12 | 0.1% | |
| 0 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 3 | < 0.1% | |
| 1 | 1369 | 6.8% | |
| 2 | 2 | < 0.1% | |
| 3 | 404 | 2.0% | |
| 4 | 105 | 0.5% |
| Value | Count | Frequency (%) | |
| 10 | 7605 | 37.5% | |
| 9 | 10390 | 51.2% | |
| 8 | 247 | 1.2% | |
| 7 | 15 | 0.1% | |
| 6 | 127 | 0.6% |
lsg_6
Real number (ℝ≥0)
| Distinct count | 1583 |
|---|---|
| Unique (%) | 7.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1265.898171 |
|---|---|
| Minimum | 0 |
| Maximum | 2065 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 150 |
| Q1 | 577.5 |
| median | 1616 |
| Q3 | 1899 |
| 95-th percentile | 1913 |
| Maximum | 2065 |
| Range | 2065 |
| Interquartile range (IQR) | 1321.5 |
Descriptive statistics
| Standard deviation | 697.8384954 |
|---|---|
| Coefficient of variation (CV) | 0.5512595813 |
| Kurtosis | -1.379955601 |
| Mean | 1265.898171 |
| Median Absolute Deviation (MAD) | 635.0477428 |
| Skewness | -0.5218620285 |
| Sum | 25671149 |
| Variance | 486978.5657 |
| Value | Count | Frequency (%) | |
| 1899 | 7276 | 35.9% | |
| 150 | 2065 | 10.2% | |
| 1913 | 566 | 2.8% | |
| 921 | 461 | 2.3% | |
| 746 | 337 | 1.7% | |
| 1778 | 302 | 1.5% | |
| 1689 | 243 | 1.2% | |
| 1266 | 192 | 0.9% | |
| 1616 | 188 | 0.9% | |
| 63 | 183 | 0.9% | |
| Other values (1573) | 8466 | 41.7% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 2 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2065 | 1 | < 0.1% | |
| 2064 | 3 | < 0.1% | |
| 2063 | 1 | < 0.1% | |
| 2062 | 1 | < 0.1% | |
| 2059 | 1 | < 0.1% |
| Distinct count | 16384 |
|---|---|
| Unique (%) | 80.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 158.6 KiB |
| 2017-03-31 12:40:24.000 | 17 |
|---|---|
| 2017-03-30 12:40:24.000 | 14 |
| 2017-04-02 14:40:24.000 | 14 |
| 2017-03-29 12:40:24.000 | 13 |
| 2017-04-01 16:40:28.000 | 13 |
| Other values (16379) |
| Value | Count | Frequency (%) | |
| 2017-03-31 12:40:24.000 | 17 | 0.1% | |
| 2017-03-30 12:40:24.000 | 14 | 0.1% | |
| 2017-04-02 14:40:24.000 | 14 | 0.1% | |
| 2017-03-29 12:40:24.000 | 13 | 0.1% | |
| 2017-04-01 16:40:28.000 | 13 | 0.1% | |
| 2017-03-29 12:42:20.000 | 13 | 0.1% | |
| 2017-04-02 16:40:25.000 | 12 | 0.1% | |
| 2017-03-29 16:40:24.000 | 12 | 0.1% | |
| 2017-03-31 14:40:24.000 | 12 | 0.1% | |
| 2017-04-02 12:40:28.000 | 12 | 0.1% | |
| Other values (16374) | 20147 | 99.3% |
Length
| Max length | 23 |
|---|---|
| Mean length | 23 |
| Min length | 23 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 71.4% | |
| Other_Punctuation | 2 | 14.3% | |
| Space_Separator | 1 | 7.1% | |
| Dash_Punctuation | 1 | 7.1% |
| Value | Count | Frequency (%) | |
| Common | 14 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 14 | 100.0% |
| Distinct count | 7210 |
|---|---|
| Unique (%) | 35.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 158.6 KiB |
| 2016-11-04 02:00:00.000 | 97 |
|---|---|
| 2016-11-05 02:00:00.000 | 96 |
| 2016-11-05 05:00:00.000 | 89 |
| 2016-11-04 03:00:00.000 | 88 |
| 2016-11-05 04:00:00.000 | 87 |
| Other values (7205) |
| Value | Count | Frequency (%) | |
| 2016-11-04 02:00:00.000 | 97 | 0.5% | |
| 2016-11-05 02:00:00.000 | 96 | 0.5% | |
| 2016-11-05 05:00:00.000 | 89 | 0.4% | |
| 2016-11-04 03:00:00.000 | 88 | 0.4% | |
| 2016-11-05 04:00:00.000 | 87 | 0.4% | |
| 2016-11-04 05:00:00.000 | 82 | 0.4% | |
| 2016-11-04 01:00:00.000 | 82 | 0.4% | |
| 2016-11-04 04:00:00.000 | 81 | 0.4% | |
| 2016-11-05 01:00:00.000 | 80 | 0.4% | |
| 2016-11-03 04:00:00.000 | 79 | 0.4% | |
| Other values (7200) | 19418 | 95.8% |
Length
| Max length | 23 |
|---|---|
| Mean length | 23 |
| Min length | 23 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 71.4% | |
| Other_Punctuation | 2 | 14.3% | |
| Space_Separator | 1 | 7.1% | |
| Dash_Punctuation | 1 | 7.1% |
| Value | Count | Frequency (%) | |
| Common | 14 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 14 | 100.0% |
is_discounted
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 158.6 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 15622 | 77.0% | |
| 1 | 4657 | 23.0% |
| Distinct count | 25 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 12956 |
| Missing (%) | 63.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.51536256 |
|---|---|
| Minimum | 5 |
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 13 |
| Q3 | 24 |
| 95-th percentile | 28 |
| Maximum | 29 |
| Range | 24 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 7.579669015 |
|---|---|
| Coefficient of variation (CV) | 0.4885267094 |
| Kurtosis | -1.386066273 |
| Mean | 15.51536256 |
| Median Absolute Deviation (MAD) | 6.841471509 |
| Skewness | 0.3927800415 |
| Sum | 113619 |
| Variance | 57.45138237 |
| Value | Count | Frequency (%) | |
| 10 | 730 | 3.6% | |
| 9 | 705 | 3.5% | |
| 8 | 601 | 3.0% | |
| 7 | 542 | 2.7% | |
| 6 | 413 | 2.0% | |
| 25 | 410 | 2.0% | |
| 27 | 383 | 1.9% | |
| 26 | 366 | 1.8% | |
| 11 | 358 | 1.8% | |
| 28 | 299 | 1.5% | |
| Other values (15) | 2516 | 12.4% | |
| (Missing) | 12956 | 63.9% |
| Value | Count | Frequency (%) | |
| 5 | 18 | 0.1% | |
| 6 | 413 | 2.0% | |
| 7 | 542 | 2.7% | |
| 8 | 601 | 3.0% | |
| 9 | 705 | 3.5% |
| Value | Count | Frequency (%) | |
| 29 | 134 | 0.7% | |
| 28 | 299 | 1.5% | |
| 27 | 383 | 1.9% | |
| 26 | 366 | 1.8% | |
| 25 | 410 | 2.0% |
price
Real number (ℝ≥0)
| Distinct count | 12959 |
|---|---|
| Unique (%) | 63.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 143.4044115 |
|---|---|
| Minimum | 0.01 |
| Maximum | 7010.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 158.6 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 17.3 |
| Q1 | 45.645 |
| median | 75.6 |
| Q3 | 126.845 |
| 95-th percentile | 522.848 |
| Maximum | 7010.27 |
| Range | 7010.26 |
| Interquartile range (IQR) | 81.2 |
Descriptive statistics
| Standard deviation | 267.2811593 |
|---|---|
| Coefficient of variation (CV) | 1.863828014 |
| Kurtosis | 84.11998212 |
| Mean | 143.4044115 |
| Median Absolute Deviation (MAD) | 122.8924222 |
| Skewness | 6.732911599 |
| Sum | 2908098.06 |
| Variance | 71439.21814 |
| Value | Count | Frequency (%) | |
| 69.59 | 8 | < 0.1% | |
| 46.25 | 8 | < 0.1% | |
| 51 | 8 | < 0.1% | |
| 50.49 | 8 | < 0.1% | |
| 59.01 | 8 | < 0.1% | |
| 32.74 | 7 | < 0.1% | |
| 43.01 | 7 | < 0.1% | |
| 45.92 | 7 | < 0.1% | |
| 41.81 | 7 | < 0.1% | |
| 69.37 | 7 | < 0.1% | |
| Other values (12949) | 20204 | 99.6% |
| Value | Count | Frequency (%) | |
| 0.01 | 1 | < 0.1% | |
| 1.25 | 1 | < 0.1% | |
| 1.26 | 1 | < 0.1% | |
| 1.28 | 1 | < 0.1% | |
| 1.3 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7010.27 | 1 | < 0.1% | |
| 6189.67 | 1 | < 0.1% | |
| 5619.61 | 1 | < 0.1% | |
| 5460.49 | 1 | < 0.1% | |
| 4903.18 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| gift_id | gift_type | gift_category | gift_cluster | instock_date | stock_update_date | lsg_1 | lsg_2 | lsg_3 | lsg_4 | lsg_5 | lsg_6 | uk_date1 | uk_date2 | is_discounted | volumes | price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | GF_11156 | 61 | 534 | 3942 | 2014-02-21 05:07:06.000 | 2016-11-09 15:49:51.000 | 3377 | 5221 | 504 | 1912 | 10 | 554 | 2014-02-24 08:07:06.000 | 2014-02-24 07:07:06.000 | 0 | NaN | 175.54 |
| 1 | GF_11157 | 61 | 534 | 3942 | 2014-02-21 06:07:06.000 | 2016-11-11 13:49:51.000 | 3377 | 5221 | 504 | 1912 | 10 | 554 | 2014-02-22 07:07:06.000 | 2014-02-24 06:07:06.000 | 1 | NaN | 95.80 |
| 2 | GF_15689 | 584 | 262 | 0 | 2014-02-21 09:30:21.000 | 2016-03-24 14:46:18.000 | 5290 | 1579 | 3203 | 1912 | 9 | 1578 | 2016-01-26 00:04:45.000 | 2016-03-18 02:00:00.000 | 1 | NaN | 107.35 |
| 3 | GF_11155 | 61 | 534 | 3942 | 2014-02-22 05:07:06.000 | 2016-11-10 16:49:51.000 | 3377 | 5221 | 504 | 1912 | 10 | 554 | 2016-11-07 13:49:51.000 | 2016-11-06 04:00:00.000 | 0 | NaN | 172.90 |
| 4 | GF_11158 | 61 | 534 | 3942 | 2014-02-22 07:07:06.000 | 2016-11-10 13:49:51.000 | 3377 | 5221 | 504 | 1912 | 9 | 554 | 2016-11-07 15:49:51.000 | 2016-11-06 01:00:00.000 | 1 | NaN | 77.72 |
| 5 | GF_15686 | 584 | 262 | 0 | 2014-02-23 07:30:21.000 | 2016-03-23 15:46:18.000 | 5290 | 1579 | 3203 | 1912 | 9 | 1578 | 2014-02-25 07:30:21.000 | 2014-02-24 08:30:21.000 | 1 | NaN | 142.84 |
| 6 | GF_15690 | 584 | 262 | 0 | 2014-02-23 10:30:21.000 | 2016-03-23 18:46:18.000 | 5290 | 1579 | 3203 | 1912 | 9 | 1578 | 2016-01-25 02:04:45.000 | 2016-03-16 02:00:00.000 | 1 | NaN | 78.71 |
| 7 | GF_15685 | 584 | 262 | 0 | 2014-02-24 10:30:21.000 | 2016-03-24 17:46:18.000 | 5290 | 1579 | 3203 | 1912 | 9 | 1578 | 2016-01-22 03:04:45.000 | 2016-03-17 03:00:00.000 | 0 | NaN | 166.81 |
| 8 | GF_11159 | 61 | 534 | 3942 | 2014-02-25 07:07:06.000 | 2016-11-10 14:49:51.000 | 3377 | 5221 | 504 | 1912 | 10 | 554 | 2016-11-07 16:49:51.000 | 2015-04-08 12:48:27.025 | 0 | NaN | 72.72 |
| 9 | GF_15688 | 584 | 262 | 0 | 2014-02-25 08:30:21.000 | 2016-03-24 16:46:18.000 | 5290 | 1579 | 3203 | 1912 | 9 | 1578 | 2016-01-23 03:04:45.000 | 2016-03-11 04:00:00.000 | 1 | NaN | 107.12 |
Last rows
| gift_id | gift_type | gift_category | gift_cluster | instock_date | stock_update_date | lsg_1 | lsg_2 | lsg_3 | lsg_4 | lsg_5 | lsg_6 | uk_date1 | uk_date2 | is_discounted | volumes | price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20269 | GF_23985 | 415 | 188 | 4256 | 2016-11-12 13:17:55.000 | 2016-11-16 12:50:47.000 | 21 | 5845 | 2438 | 1912 | 10 | 150 | 2016-11-16 12:50:47.000 | 2016-10-30 02:00:00.000 | 1 | NaN | 37.31 |
| 20270 | GF_9030 | 1173 | 534 | 4261 | 2016-11-12 13:17:57.000 | 2016-11-15 11:17:57.000 | 600 | 163 | 6710 | 1912 | 10 | 1899 | 2016-11-13 12:17:57.000 | 2016-11-03 03:00:00.000 | 1 | NaN | 35.61 |
| 20271 | GF_22761 | 1262 | 433 | 5487 | 2016-11-12 13:18:10.000 | 2016-11-17 11:18:10.000 | 1491 | 6883 | 2870 | 1912 | 10 | 921 | 2016-11-11 14:18:10.000 | 2016-11-04 05:00:00.000 | 1 | NaN | 36.26 |
| 20272 | GF_13772 | 531 | 433 | 5980 | 2016-11-12 13:23:35.000 | 2016-11-15 13:23:35.000 | 5056 | 5490 | 2954 | 1912 | 10 | 2038 | 2016-11-15 14:23:35.000 | 2016-11-13 13:23:35.000 | 1 | NaN | 24.71 |
| 20273 | GF_10352 | 1262 | 433 | 42 | 2016-11-12 13:26:09.000 | 2016-11-17 11:26:09.000 | 1480 | 6883 | 3747 | 1912 | 10 | 1899 | 2016-11-12 14:26:09.000 | 2016-11-10 03:00:00.000 | 1 | NaN | 22.02 |
| 20274 | GF_10269 | 105 | 704 | 6448 | 2016-11-12 13:46:42.000 | 2016-11-17 10:46:42.000 | 2055 | 6883 | 995 | 1912 | 10 | 1899 | 2016-11-14 14:46:42.000 | 2016-11-11 03:00:00.000 | 0 | NaN | 57.68 |
| 20275 | GF_5854 | 1220 | 526 | 817 | 2016-11-12 13:46:47.000 | 2016-11-18 13:46:47.000 | 8323 | 6753 | 6706 | 1912 | 10 | 1899 | 2016-11-13 10:46:47.000 | 2016-10-28 02:00:00.000 | 0 | NaN | 122.87 |
| 20276 | GF_563 | 509 | 705 | 821 | 2016-11-12 13:46:57.000 | 2017-01-21 19:30:04.000 | 2826 | 4009 | 2912 | 1912 | 10 | 1451 | 2017-01-21 18:30:04.000 | 2017-01-18 01:00:00.000 | 0 | NaN | 47.14 |
| 20277 | GF_9107 | 682 | 213 | 5620 | 2016-11-12 13:47:01.000 | 2016-11-18 11:47:01.000 | 2089 | 6883 | 3607 | 1912 | 10 | 822 | 2016-11-14 12:47:01.000 | 2016-11-13 02:00:00.000 | 0 | NaN | 47.68 |
| 20278 | GF_5683 | 1061 | 212 | 4987 | 2016-11-12 13:48:30.000 | 2016-11-18 12:48:30.000 | 898 | 1814 | 6109 | 1912 | 10 | 1899 | 2016-11-12 10:48:30.000 | 2016-11-10 02:00:00.000 | 0 | NaN | 52.81 |